﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace DBService
{
   public  interface IDBService
    {
       DataTable Select(string sql, string conectionString);
       object ExcecuteScalar(string sql, string conectionString);
       int ExecuteNonQuery(string sql, string conectionString);
       DataTable ExcecuteStoredProcedure(string conectionString,string procedure_name, DBParameterCollentions paras);

       /// <summary>
       /// 
       /// </summary>
       /// <param name="sql"></param>
       /// <returns></returns>
       string ToPaginatedSql(string sql,long rows,long pageIndex);
       string ToCountedSql(string sql);
    }
    
}
